package com.wva.video.mapper;

import com.github.pagehelper.Page;
import com.wva.video.domain.po.Video;
import com.wva.video.domain.po.VideoCollect;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author hong
 * @since 2025-03-09
 */
public interface VideoCollectMapper extends BaseMapper<VideoCollect> {
    @Select("select v.* from video v left join video_collect c on v.id=c.video_id where c.user_id = #{userId}")
    Page<Video> listUserCollectVideoByPage(long userId);
}
